<html>
<body>
<h1>Klantgegevens</h1>
<?php

require('../connect_db.php');

$klant_result = mysql_query("SELECT * FROM klantgegevens ORDER BY Klantnr");

echo "<table border='1'>
	<tr>
			<td width='150' align='center'><strong>Klantnr</strong></td>		
			<td width='150' align='center'><strong>Voornaam</strong></td>
			<td width='150' align='center'><strong>Achternaam</strong></td>
			<td width='150' align='center'><strong>Adres</strong></td>
			<td width='150' align='center'><strong>Postcode</strong></td>
			<td width='150' align='center'><strong>Plaats</strong></td>
			<td width='150' align='center'><strong>Telefoonnummer</strong></td>
			<td width='150' align='center'><strong>Emailadres</strong></td>
			<td width='150' align='center'><strong>Wijzigen</strong></td>
	</tr>";
	
while($klant_row = mysql_fetch_array($klant_result))
	{
		$klant_id = $klant_row['Klantnr'];
		echo "<tr>
					<td align='left'>".$klant_row['Klantnr']."</td>
					<td align='left'>".$klant_row['Voornaam']."</td>
					<td align='left'>".$klant_row['Achternaam']."</td>
					<td align='left'>".$klant_row['Adres']."</td>
					<td align='left'>".$klant_row['Postcode']."</td>
					<td align='left'>".$klant_row['Plaats']."</td>
					<td align='left'>".$klant_row['Telefoonnummer']."</td>
					<td align='left'>".$klant_row['Emailadres']."</td>
					<td align='center'>".$wijzigen= "<a href='klantgegevens_wijzigen.php?id=$klant_id'>".'<img src="http://www.esteriann.nl/Kladblok.jpg" img border = "0" width="32" height="32" />'."</td>
					</tr>";
	}
?>
</body>
<html>